Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAccountTypeCode (PK) | Determines what kind of customer account this is. Examples include a trade account, a school account, a not-for-profit, regular customer, etc. LOYALTY - customer loyalty account for tracking points earned/redeemed REBATE -Customer reward account that pays customers based on cumulative net purchases over a deisgnated period of time TRADE - customer business credit account CONSUMER_CHG - customer individual consumer credit extended by retailer INSTALLMENT - credit account set up for one time purchase LAYAWAY - cash time payment account (not credit) RENTAL - customer rental for videos, equipment WORKORDER - account for handling services like installation and set up BACKORDER - account for handling backorder deposit and adjustments. | TY_CTAC | Code | varchar(20) | |
CustomerAccountTypeDescription | Short business description of the CustomerAccountType. | DE_CT_ACNT_TYP | DescriptionShort | varchar(255) | |
CustomerIdentityRequiredFlag | Flag that if set to true requires the customer to provide proof of his/her identity to verify that he/she may use the CUSTOMER ACCOUNT. | FL_IDN_CT_RQ | Flag | integer | |
CustomerIdentityTypeCode | Determines the type of customer identification proof required. Examples include drivers license, store charge card, trade association identification card, etc. | TY_IDN_CT | Code2 | char(2) | |